﻿CREATE PROCEDURE [dbo].[categories_delete]
@categoryId int

AS
DELETE FROM [dbo].[BooksByCategory]
WHERE
    [BooksByCategory].[CategoryId]=@categoryId


DELETE FROM [dbo].[Categories]

WHERE
    Categories.[CategoryId]=@categoryId

RETURN 0
